package com.weimall.pojo;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

public class SpPriceExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public SpPriceExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andCkbmIsNull() {
            addCriterion("CKBM is null");
            return (Criteria) this;
        }

        public Criteria andCkbmIsNotNull() {
            addCriterion("CKBM is not null");
            return (Criteria) this;
        }

        public Criteria andCkbmEqualTo(String value) {
            addCriterion("CKBM =", value, "ckbm");
            return (Criteria) this;
        }

        public Criteria andCkbmNotEqualTo(String value) {
            addCriterion("CKBM <>", value, "ckbm");
            return (Criteria) this;
        }

        public Criteria andCkbmGreaterThan(String value) {
            addCriterion("CKBM >", value, "ckbm");
            return (Criteria) this;
        }

        public Criteria andCkbmGreaterThanOrEqualTo(String value) {
            addCriterion("CKBM >=", value, "ckbm");
            return (Criteria) this;
        }

        public Criteria andCkbmLessThan(String value) {
            addCriterion("CKBM <", value, "ckbm");
            return (Criteria) this;
        }

        public Criteria andCkbmLessThanOrEqualTo(String value) {
            addCriterion("CKBM <=", value, "ckbm");
            return (Criteria) this;
        }

        public Criteria andCkbmLike(String value) {
            addCriterion("CKBM like", value, "ckbm");
            return (Criteria) this;
        }

        public Criteria andCkbmNotLike(String value) {
            addCriterion("CKBM not like", value, "ckbm");
            return (Criteria) this;
        }

        public Criteria andCkbmIn(List<String> values) {
            addCriterion("CKBM in", values, "ckbm");
            return (Criteria) this;
        }

        public Criteria andCkbmNotIn(List<String> values) {
            addCriterion("CKBM not in", values, "ckbm");
            return (Criteria) this;
        }

        public Criteria andCkbmBetween(String value1, String value2) {
            addCriterion("CKBM between", value1, value2, "ckbm");
            return (Criteria) this;
        }

        public Criteria andCkbmNotBetween(String value1, String value2) {
            addCriterion("CKBM not between", value1, value2, "ckbm");
            return (Criteria) this;
        }

        public Criteria andSpbmIsNull() {
            addCriterion("SPBM is null");
            return (Criteria) this;
        }

        public Criteria andSpbmIsNotNull() {
            addCriterion("SPBM is not null");
            return (Criteria) this;
        }

        public Criteria andSpbmEqualTo(String value) {
            addCriterion("SPBM =", value, "spbm");
            return (Criteria) this;
        }

        public Criteria andSpbmNotEqualTo(String value) {
            addCriterion("SPBM <>", value, "spbm");
            return (Criteria) this;
        }

        public Criteria andSpbmGreaterThan(String value) {
            addCriterion("SPBM >", value, "spbm");
            return (Criteria) this;
        }

        public Criteria andSpbmGreaterThanOrEqualTo(String value) {
            addCriterion("SPBM >=", value, "spbm");
            return (Criteria) this;
        }

        public Criteria andSpbmLessThan(String value) {
            addCriterion("SPBM <", value, "spbm");
            return (Criteria) this;
        }

        public Criteria andSpbmLessThanOrEqualTo(String value) {
            addCriterion("SPBM <=", value, "spbm");
            return (Criteria) this;
        }

        public Criteria andSpbmLike(String value) {
            addCriterion("SPBM like", value, "spbm");
            return (Criteria) this;
        }

        public Criteria andSpbmNotLike(String value) {
            addCriterion("SPBM not like", value, "spbm");
            return (Criteria) this;
        }

        public Criteria andSpbmIn(List<String> values) {
            addCriterion("SPBM in", values, "spbm");
            return (Criteria) this;
        }

        public Criteria andSpbmNotIn(List<String> values) {
            addCriterion("SPBM not in", values, "spbm");
            return (Criteria) this;
        }

        public Criteria andSpbmBetween(String value1, String value2) {
            addCriterion("SPBM between", value1, value2, "spbm");
            return (Criteria) this;
        }

        public Criteria andSpbmNotBetween(String value1, String value2) {
            addCriterion("SPBM not between", value1, value2, "spbm");
            return (Criteria) this;
        }

        public Criteria andCkmcIsNull() {
            addCriterion("CKMC is null");
            return (Criteria) this;
        }

        public Criteria andCkmcIsNotNull() {
            addCriterion("CKMC is not null");
            return (Criteria) this;
        }

        public Criteria andCkmcEqualTo(String value) {
            addCriterion("CKMC =", value, "ckmc");
            return (Criteria) this;
        }

        public Criteria andCkmcNotEqualTo(String value) {
            addCriterion("CKMC <>", value, "ckmc");
            return (Criteria) this;
        }

        public Criteria andCkmcGreaterThan(String value) {
            addCriterion("CKMC >", value, "ckmc");
            return (Criteria) this;
        }

        public Criteria andCkmcGreaterThanOrEqualTo(String value) {
            addCriterion("CKMC >=", value, "ckmc");
            return (Criteria) this;
        }

        public Criteria andCkmcLessThan(String value) {
            addCriterion("CKMC <", value, "ckmc");
            return (Criteria) this;
        }

        public Criteria andCkmcLessThanOrEqualTo(String value) {
            addCriterion("CKMC <=", value, "ckmc");
            return (Criteria) this;
        }

        public Criteria andCkmcLike(String value) {
            addCriterion("CKMC like", value, "ckmc");
            return (Criteria) this;
        }

        public Criteria andCkmcNotLike(String value) {
            addCriterion("CKMC not like", value, "ckmc");
            return (Criteria) this;
        }

        public Criteria andCkmcIn(List<String> values) {
            addCriterion("CKMC in", values, "ckmc");
            return (Criteria) this;
        }

        public Criteria andCkmcNotIn(List<String> values) {
            addCriterion("CKMC not in", values, "ckmc");
            return (Criteria) this;
        }

        public Criteria andCkmcBetween(String value1, String value2) {
            addCriterion("CKMC between", value1, value2, "ckmc");
            return (Criteria) this;
        }

        public Criteria andCkmcNotBetween(String value1, String value2) {
            addCriterion("CKMC not between", value1, value2, "ckmc");
            return (Criteria) this;
        }

        public Criteria andPfjIsNull() {
            addCriterion("PFJ is null");
            return (Criteria) this;
        }

        public Criteria andPfjIsNotNull() {
            addCriterion("PFJ is not null");
            return (Criteria) this;
        }

        public Criteria andPfjEqualTo(BigDecimal value) {
            addCriterion("PFJ =", value, "pfj");
            return (Criteria) this;
        }

        public Criteria andPfjNotEqualTo(BigDecimal value) {
            addCriterion("PFJ <>", value, "pfj");
            return (Criteria) this;
        }

        public Criteria andPfjGreaterThan(BigDecimal value) {
            addCriterion("PFJ >", value, "pfj");
            return (Criteria) this;
        }

        public Criteria andPfjGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PFJ >=", value, "pfj");
            return (Criteria) this;
        }

        public Criteria andPfjLessThan(BigDecimal value) {
            addCriterion("PFJ <", value, "pfj");
            return (Criteria) this;
        }

        public Criteria andPfjLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PFJ <=", value, "pfj");
            return (Criteria) this;
        }

        public Criteria andPfjIn(List<BigDecimal> values) {
            addCriterion("PFJ in", values, "pfj");
            return (Criteria) this;
        }

        public Criteria andPfjNotIn(List<BigDecimal> values) {
            addCriterion("PFJ not in", values, "pfj");
            return (Criteria) this;
        }

        public Criteria andPfjBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PFJ between", value1, value2, "pfj");
            return (Criteria) this;
        }

        public Criteria andPfjNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PFJ not between", value1, value2, "pfj");
            return (Criteria) this;
        }

        public Criteria andLsjIsNull() {
            addCriterion("LSJ is null");
            return (Criteria) this;
        }

        public Criteria andLsjIsNotNull() {
            addCriterion("LSJ is not null");
            return (Criteria) this;
        }

        public Criteria andLsjEqualTo(BigDecimal value) {
            addCriterion("LSJ =", value, "lsj");
            return (Criteria) this;
        }

        public Criteria andLsjNotEqualTo(BigDecimal value) {
            addCriterion("LSJ <>", value, "lsj");
            return (Criteria) this;
        }

        public Criteria andLsjGreaterThan(BigDecimal value) {
            addCriterion("LSJ >", value, "lsj");
            return (Criteria) this;
        }

        public Criteria andLsjGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("LSJ >=", value, "lsj");
            return (Criteria) this;
        }

        public Criteria andLsjLessThan(BigDecimal value) {
            addCriterion("LSJ <", value, "lsj");
            return (Criteria) this;
        }

        public Criteria andLsjLessThanOrEqualTo(BigDecimal value) {
            addCriterion("LSJ <=", value, "lsj");
            return (Criteria) this;
        }

        public Criteria andLsjIn(List<BigDecimal> values) {
            addCriterion("LSJ in", values, "lsj");
            return (Criteria) this;
        }

        public Criteria andLsjNotIn(List<BigDecimal> values) {
            addCriterion("LSJ not in", values, "lsj");
            return (Criteria) this;
        }

        public Criteria andLsjBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LSJ between", value1, value2, "lsj");
            return (Criteria) this;
        }

        public Criteria andLsjNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LSJ not between", value1, value2, "lsj");
            return (Criteria) this;
        }

        public Criteria andHyjIsNull() {
            addCriterion("HYJ is null");
            return (Criteria) this;
        }

        public Criteria andHyjIsNotNull() {
            addCriterion("HYJ is not null");
            return (Criteria) this;
        }

        public Criteria andHyjEqualTo(BigDecimal value) {
            addCriterion("HYJ =", value, "hyj");
            return (Criteria) this;
        }

        public Criteria andHyjNotEqualTo(BigDecimal value) {
            addCriterion("HYJ <>", value, "hyj");
            return (Criteria) this;
        }

        public Criteria andHyjGreaterThan(BigDecimal value) {
            addCriterion("HYJ >", value, "hyj");
            return (Criteria) this;
        }

        public Criteria andHyjGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("HYJ >=", value, "hyj");
            return (Criteria) this;
        }

        public Criteria andHyjLessThan(BigDecimal value) {
            addCriterion("HYJ <", value, "hyj");
            return (Criteria) this;
        }

        public Criteria andHyjLessThanOrEqualTo(BigDecimal value) {
            addCriterion("HYJ <=", value, "hyj");
            return (Criteria) this;
        }

        public Criteria andHyjIn(List<BigDecimal> values) {
            addCriterion("HYJ in", values, "hyj");
            return (Criteria) this;
        }

        public Criteria andHyjNotIn(List<BigDecimal> values) {
            addCriterion("HYJ not in", values, "hyj");
            return (Criteria) this;
        }

        public Criteria andHyjBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HYJ between", value1, value2, "hyj");
            return (Criteria) this;
        }

        public Criteria andHyjNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HYJ not between", value1, value2, "hyj");
            return (Criteria) this;
        }

        public Criteria andP1IsNull() {
            addCriterion("P1 is null");
            return (Criteria) this;
        }

        public Criteria andP1IsNotNull() {
            addCriterion("P1 is not null");
            return (Criteria) this;
        }

        public Criteria andP1EqualTo(BigDecimal value) {
            addCriterion("P1 =", value, "p1");
            return (Criteria) this;
        }

        public Criteria andP1NotEqualTo(BigDecimal value) {
            addCriterion("P1 <>", value, "p1");
            return (Criteria) this;
        }

        public Criteria andP1GreaterThan(BigDecimal value) {
            addCriterion("P1 >", value, "p1");
            return (Criteria) this;
        }

        public Criteria andP1GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("P1 >=", value, "p1");
            return (Criteria) this;
        }

        public Criteria andP1LessThan(BigDecimal value) {
            addCriterion("P1 <", value, "p1");
            return (Criteria) this;
        }

        public Criteria andP1LessThanOrEqualTo(BigDecimal value) {
            addCriterion("P1 <=", value, "p1");
            return (Criteria) this;
        }

        public Criteria andP1In(List<BigDecimal> values) {
            addCriterion("P1 in", values, "p1");
            return (Criteria) this;
        }

        public Criteria andP1NotIn(List<BigDecimal> values) {
            addCriterion("P1 not in", values, "p1");
            return (Criteria) this;
        }

        public Criteria andP1Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("P1 between", value1, value2, "p1");
            return (Criteria) this;
        }

        public Criteria andP1NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("P1 not between", value1, value2, "p1");
            return (Criteria) this;
        }

        public Criteria andP2IsNull() {
            addCriterion("P2 is null");
            return (Criteria) this;
        }

        public Criteria andP2IsNotNull() {
            addCriterion("P2 is not null");
            return (Criteria) this;
        }

        public Criteria andP2EqualTo(BigDecimal value) {
            addCriterion("P2 =", value, "p2");
            return (Criteria) this;
        }

        public Criteria andP2NotEqualTo(BigDecimal value) {
            addCriterion("P2 <>", value, "p2");
            return (Criteria) this;
        }

        public Criteria andP2GreaterThan(BigDecimal value) {
            addCriterion("P2 >", value, "p2");
            return (Criteria) this;
        }

        public Criteria andP2GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("P2 >=", value, "p2");
            return (Criteria) this;
        }

        public Criteria andP2LessThan(BigDecimal value) {
            addCriterion("P2 <", value, "p2");
            return (Criteria) this;
        }

        public Criteria andP2LessThanOrEqualTo(BigDecimal value) {
            addCriterion("P2 <=", value, "p2");
            return (Criteria) this;
        }

        public Criteria andP2In(List<BigDecimal> values) {
            addCriterion("P2 in", values, "p2");
            return (Criteria) this;
        }

        public Criteria andP2NotIn(List<BigDecimal> values) {
            addCriterion("P2 not in", values, "p2");
            return (Criteria) this;
        }

        public Criteria andP2Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("P2 between", value1, value2, "p2");
            return (Criteria) this;
        }

        public Criteria andP2NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("P2 not between", value1, value2, "p2");
            return (Criteria) this;
        }

        public Criteria andP3IsNull() {
            addCriterion("P3 is null");
            return (Criteria) this;
        }

        public Criteria andP3IsNotNull() {
            addCriterion("P3 is not null");
            return (Criteria) this;
        }

        public Criteria andP3EqualTo(BigDecimal value) {
            addCriterion("P3 =", value, "p3");
            return (Criteria) this;
        }

        public Criteria andP3NotEqualTo(BigDecimal value) {
            addCriterion("P3 <>", value, "p3");
            return (Criteria) this;
        }

        public Criteria andP3GreaterThan(BigDecimal value) {
            addCriterion("P3 >", value, "p3");
            return (Criteria) this;
        }

        public Criteria andP3GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("P3 >=", value, "p3");
            return (Criteria) this;
        }

        public Criteria andP3LessThan(BigDecimal value) {
            addCriterion("P3 <", value, "p3");
            return (Criteria) this;
        }

        public Criteria andP3LessThanOrEqualTo(BigDecimal value) {
            addCriterion("P3 <=", value, "p3");
            return (Criteria) this;
        }

        public Criteria andP3In(List<BigDecimal> values) {
            addCriterion("P3 in", values, "p3");
            return (Criteria) this;
        }

        public Criteria andP3NotIn(List<BigDecimal> values) {
            addCriterion("P3 not in", values, "p3");
            return (Criteria) this;
        }

        public Criteria andP3Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("P3 between", value1, value2, "p3");
            return (Criteria) this;
        }

        public Criteria andP3NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("P3 not between", value1, value2, "p3");
            return (Criteria) this;
        }

        public Criteria andP4IsNull() {
            addCriterion("P4 is null");
            return (Criteria) this;
        }

        public Criteria andP4IsNotNull() {
            addCriterion("P4 is not null");
            return (Criteria) this;
        }

        public Criteria andP4EqualTo(BigDecimal value) {
            addCriterion("P4 =", value, "p4");
            return (Criteria) this;
        }

        public Criteria andP4NotEqualTo(BigDecimal value) {
            addCriterion("P4 <>", value, "p4");
            return (Criteria) this;
        }

        public Criteria andP4GreaterThan(BigDecimal value) {
            addCriterion("P4 >", value, "p4");
            return (Criteria) this;
        }

        public Criteria andP4GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("P4 >=", value, "p4");
            return (Criteria) this;
        }

        public Criteria andP4LessThan(BigDecimal value) {
            addCriterion("P4 <", value, "p4");
            return (Criteria) this;
        }

        public Criteria andP4LessThanOrEqualTo(BigDecimal value) {
            addCriterion("P4 <=", value, "p4");
            return (Criteria) this;
        }

        public Criteria andP4In(List<BigDecimal> values) {
            addCriterion("P4 in", values, "p4");
            return (Criteria) this;
        }

        public Criteria andP4NotIn(List<BigDecimal> values) {
            addCriterion("P4 not in", values, "p4");
            return (Criteria) this;
        }

        public Criteria andP4Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("P4 between", value1, value2, "p4");
            return (Criteria) this;
        }

        public Criteria andP4NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("P4 not between", value1, value2, "p4");
            return (Criteria) this;
        }

        public Criteria andP5IsNull() {
            addCriterion("P5 is null");
            return (Criteria) this;
        }

        public Criteria andP5IsNotNull() {
            addCriterion("P5 is not null");
            return (Criteria) this;
        }

        public Criteria andP5EqualTo(BigDecimal value) {
            addCriterion("P5 =", value, "p5");
            return (Criteria) this;
        }

        public Criteria andP5NotEqualTo(BigDecimal value) {
            addCriterion("P5 <>", value, "p5");
            return (Criteria) this;
        }

        public Criteria andP5GreaterThan(BigDecimal value) {
            addCriterion("P5 >", value, "p5");
            return (Criteria) this;
        }

        public Criteria andP5GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("P5 >=", value, "p5");
            return (Criteria) this;
        }

        public Criteria andP5LessThan(BigDecimal value) {
            addCriterion("P5 <", value, "p5");
            return (Criteria) this;
        }

        public Criteria andP5LessThanOrEqualTo(BigDecimal value) {
            addCriterion("P5 <=", value, "p5");
            return (Criteria) this;
        }

        public Criteria andP5In(List<BigDecimal> values) {
            addCriterion("P5 in", values, "p5");
            return (Criteria) this;
        }

        public Criteria andP5NotIn(List<BigDecimal> values) {
            addCriterion("P5 not in", values, "p5");
            return (Criteria) this;
        }

        public Criteria andP5Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("P5 between", value1, value2, "p5");
            return (Criteria) this;
        }

        public Criteria andP5NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("P5 not between", value1, value2, "p5");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}